Create and Manage Product Batches
To create and view unique batch records for items, including manufacturing dates, expiry dates, and specific pricing,
So that I can ensure product traceability, manage shelf life, and maintain accurate inventory valuation.
1. Batch Creation (Add Batch Form)
- Unique Identification: The system must allow the user to input a Batch No (required).
- Item Selection: The user must be able to select an existing item from a searchable Select Item dropdown menu.
- Pricing: The system must provide a field for MRP (Excluding GST) to define the price specific to that batch.
- Date Tracking:
- The user must be able to select a Manufacture Date via a calendar picker.
- The user must be able to select an Expiry Date via a calendar picker.
- Submission: Clicking the Save button should validate the required fields and add the batch to the database.
2. Batch Management (View List)
- Data Grid: The system must display a table of all existing batches with the following columns:
- Batch Number, Item Name, MRP, Manufacturing Date, and Expiry Date.
- Search & Filter: Users must be able to use a Search bar to find specific batches and use the Show Entries dropdown to adjust the number of rows displayed.
- Navigation:
- A View List button on the creation form to return to the table.
- An Add button on the list view to navigate to the creation form.
- Actions: Each row must have an Action menu (three dots) to allow for editing or deleting batch records.
- Data Export: A Download button should allow users to export the batch list (e.g., to Excel or PDF).
Technical Constraints & Business Rules
- Validation: The Expiry Date should logically be set after the Manufacture Date.
- Traceability: Once a batch is linked to a sales or purchase transaction, the system should prevent deletion to maintain audit trails.
- GST Calculation: The system labels the MRP as "Excluding GST," implying that tax calculations are handled at the invoicing level rather than the batch creation level.